The Savings Balances Report displays clients' savings balances at a specified reporting date. It has 2 tabs, i.e., Savings Balances Report and the Group Member's Savings Balances report tabs.
How to view the Savings Balances Report
To view the savings balances report you go to Savings->Savings Reports->Savings Balances Report. A screen will appear looking as follows:
Reporting date: Specify the Reporting date, e.g., "28/03/2013".
Report currency: From the drop down list select the currency in which the report will appear, e.g., "UGX".
Branch Code: Choose a specific branch codethat you want to be reported on from the drop-down or tick the Check for all option to include all branches.
Product: Choose a specific savings product that you want to be reported on from the drop-down or tick the Check for all option to include all products.
Geographical Area: Choose a specific geographical areathat you want to be reported on from the drop-down or tick the Check for all option to include all areas.
Client category 1: Choose a client category 1 optionthat you want to be reported on from the drop-down or tick the Check for all option to include clients in category 1.
Client category 2: Choose a client category 2 optionthat you want to be reported on from the drop-down or tick the Check for all option to include all clients in category 2.
Client category 3: Choose a client category 3optionthat you want to be reported on from the drop-down or tick the Check for all option to include all clients in category 3.
Cost centre: Choose a specific cost centrethat you want to be reported on from the drop-down or tick the Check for all option to include all cost centres.
Gender: Choose the gender from the drop-down or tick the check-box Check for all to include both sexes.
Balances between: Enter the range for the savings amount that you would like to have the report about , e.g,. "2,000 - 40,000,000". This will enable you to see the clients who have savings in the range selected. You can also select the Check for all option to have the savings balances report for all clients.
Note that running the Savings balances report with a range that includes negative balances entered under the feature "Balances between" e.g between "-50,000 to 0" should give the same results as “Overdraft balances report for the same range under Savings\Overdrafts\ Overdraft balances report.
There are various options to select from basing on the details one wants include in the savings balances report, e.g., displaying savings balances for:
All accounts: Select this option to get the savings balances report for all accounts available in the system with their corresponding balances.
Example: Let's look at some of the reports generated when the option "All Accounts" is selected for the type of savings balances report. When you look at the report below; a client KA/I/000001 has 3 savings products (i.e., S000, S002, T000) on which he has savings of 58,323,000, 1,700,000 and 1,000,000 respectively.
In the report each account holder's savings balances are shown as per savings products held. The total for all the savings accounts are also shown at the bottom of the page.
Consolidated per account : When this option is selected, a client having savings in more than one savings product will have his/her savings amount shown as one block amount.
For example, if Kijambu Bridget has savings of 2,000,000 on Free Savings and 4,100,000 on Loan Guarantee Savings. When this option is selected, Kijambu Bridget will have a savings balance of 6,100,000 (one block figure that is not split) displayed in the Savings Balances Report as shown below:
From the report above: Kijambu Bridget's account shows 6,100,000 as the savings amount. This means that all the savings balances made under various savings products held have been consolidated (Summed up).
Summary of balances: When this option is selected, the total amount of savings made as per the reporting date selected will be displayed without showing the corresponding savings accounts, i.e., there will be no break down of the savings amounts displayed as shown below:
The savings balance report can also be filtered using the options:
Select any other required additional options or use the default selections. For additional information on these options you can refer to Savings Report Formats.
Click on the OK command button to view the report which will look similar to the following:
